X14ConditionalFormattingRule Properties

Properties

AboveAverage Gets or sets whether an average rule matches above-average values.
ActivePresent Gets or sets whether the rule is active in the legacy part of the document.
Bottom Gets or sets whether a top/bottom rule matches bottom values.
DataBar Gets or sets the data bar definition.
EqualAverage Gets or sets whether an average rule includes equal-to-average values.
Format Gets or sets the differential format (x14:dxf element) applied when the rule matches.
Formulas Gets the rule formulas (xm:f elements).
IconSet Gets or sets the icon set definition.
Id Gets or sets the rule id (GUID) that links this rule to its main-namespace counterpart.
Operator Gets or sets the comparison operator.
Percent Gets or sets whether a top/bottom rule uses a percentage.
Priority Gets or sets the rule priority.
Rank Gets or sets the rank of a top/bottom rule.
StandardDeviation Gets or sets the number of standard deviations of an average rule.
StopIfTrue Gets or sets whether rule evaluation stops when this rule matches.
Text Gets or sets the text value of a text rule.
TimePeriod Gets or sets the time period of a date rule.
Type Gets or sets the rule type (e.g. "dataBar", "iconSet", "expression", "cellIs").

See Also